--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:/Users/agerster/Dropbox/Projekt_Gebaeudeausweis/Auswertung JAERE_final/log/2019_6_5_analyses_disclosure.log
  log type:  text
 opened on:   5 Jun 2019, 14:35:57

. **************
. **************
. * Analyses
. **************
. **************
. 
. global merkat baujahr_adopt modern_adopt objektkat qualitaet heizart

. global merkat_i ""

. foreach x of global merkat {
  2.         global merkat_i $merkat_i i.`x' 
  3. }

. global merkont grundflaeche wohnflaeche zimmer_cont grundflaeche2 wohnflaeche2 

. 
. gen missing_test = 0

. foreach var of global merkont {
  2.         replace missing_test = 1 if missing(`var')
  3. }
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)
(0 real changes made)

. 
. 
. 
. ***
. * Table 3: OLS Regression Results for Linear Probability Model
. ***
. 
. * recode variables (for better readability)
. replace grundflaeche = grundflaeche / 1000
(350,749 real changes made)

. replace grundflaeche2 = grundflaeche2 / 1000^2
(350,749 real changes made)

. replace wohnflaeche= wohnflaeche / 100
(350,749 real changes made)

. replace wohnflaeche2 = wohnflaeche2 / 100^2
(350,749 real changes made)

. 
. xtset plz
       panel variable:  plz (unbalanced)

. xtreg epc $merkat_i $merkont ib1.objektzus ib5.anbietertyp##postmai ${ifnotlastmonth}, fe

Fixed-effects (within) regression               Number of obs     =    312,899
Group variable: plz                             Number of groups  =      8,961

R-sq:                                           Obs per group:
     within  = 0.3731                                         min =          1
     between = 0.2955                                         avg =       34.9
     overall = 0.3697                                         max =        471

                                                F(26,303912)      =    6956.02
corr(u_i, Xb)  = -0.0034                        Prob > F          =     0.0000

-------------------------------------------------------------------------------------
                epc |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------------+----------------------------------------------------------------
      baujahr_adopt |
              1977  |   .0289454   .0016702    17.33   0.000      .025672    .0322189
              2002  |   .0317577   .0026278    12.09   0.000     .0266072    .0369081
                    |
       modern_adopt |
              1977  |   .0239063   .0107201     2.23   0.026     .0028952    .0449174
              2002  |   .0218602   .0105151     2.08   0.038     .0012509    .0424694
              9999  |  -.0141867   .0104142    -1.36   0.173    -.0345981    .0062248
                    |
          objektkat |
               MFH  |  -.0089464   .0028343    -3.16   0.002    -.0145016   -.0033913
     EFH, Bungalow  |  -.0010836   .0019305    -0.56   0.575    -.0048672    .0027001
                kA  |  -.1274471   .0026759   -47.63   0.000    -.1326917   -.1222025
                    |
          qualitaet |
            normal  |  -.0239837   .0025048    -9.58   0.000    -.0288931   -.0190744
           einfach  |  -.0410038   .0043095    -9.51   0.000    -.0494503   -.0325572
                kA  |  -.0348151   .0023676   -14.70   0.000    -.0394556   -.0301745
                    |
            heizart |
     Etagenheizung  |  -.0126716   .0043164    -2.94   0.003    -.0211317   -.0042116
       Ofenheizung  |  -.0197205   .0046822    -4.21   0.000    -.0288975   -.0105435
                kA  |  -.0701075   .0015968   -43.91   0.000    -.0732371   -.0669779
                    |
       grundflaeche |   .0021821   .0031728     0.69   0.492    -.0040364    .0084006
        wohnflaeche |   .0152005   .0044259     3.43   0.001     .0065258    .0238752
        zimmer_cont |   .0046178   .0004609    10.02   0.000     .0037144    .0055211
      grundflaeche2 |  -.0022329   .0007535    -2.96   0.003    -.0037097   -.0007561
       wohnflaeche2 |  -.0052135    .000884    -5.90   0.000    -.0069461   -.0034809
                    |
          objektzus |
  renovierungsbed.  |  -.0513453   .0024533   -20.93   0.000    -.0561537   -.0465369
                kA  |  -.0580492   .0017108   -33.93   0.000    -.0614024    -.054696
                    |
        anbietertyp |
          Finanzen  |   .0019831   .0036113     0.55   0.583    -.0050948    .0090611
            Makler  |  -.0124656   .0032219    -3.87   0.000    -.0187804   -.0061507
                    |
          1.postmai |   .2682412   .0045449    59.02   0.000     .2593334     .277149
                    |
anbietertyp#postmai |
        Finanzen#1  |   .4518283    .005216    86.62   0.000     .4416052    .4620515
          Makler#1  |   .2115058    .004831    43.78   0.000     .2020371    .2209744
                    |
              _cons |   .1235171    .011779    10.49   0.000     .1004307    .1466035
--------------------+----------------------------------------------------------------
            sigma_u |   .1761904
            sigma_e |     .36844
                rho |  .18611941   (fraction of variance due to u_i)
-------------------------------------------------------------------------------------
F test that all u_i=0: F(8960, 303912) = 1.78                Prob > F = 0.0000

. est sto disclosure

. 
. estout disclosure, ///
>         cells("b(star label(Coeff.) fmt(%12.2gc)) se(label(Std. Err.) fmt(%12.2gc))") ///
>         starlevels(* 0.05 ** 0.01) ///
>         stats(N, fmt(%12.0fc)) ///
>         nobaselevels ///
>         varlabels( ///
>         1900.baujahr_adopt "1900-1976" 1977.baujahr_adopt "1977-2002" 2002.baujahr_adopt "2002-2015" 9999.baujahr_adopt "n.a." ///
>         1900.modern_adopt "1900-1976" 1977.modern_adopt "1977-2001" 2002.modern_adopt "2002-2015" 9999.modern_adopt "n.a." ///
>         2.objektkat "Multi-family house" 3.objektkat "One-family house" 99.objektkat "n.a." ///
>         2.anbietertyp "Banks" 4.anbietertyp "Agents" 5.anbietertyp "Private" ///
>         1.postmai "PostApril" ///
>         2.anbietertyp#1.postmai "Banks*PostApril" 4.anbietertyp#1.postmai "Agents*PostApril" ///
>         0.objektzus "Yes" 1.objektzus "No" 99.objektzus "n.a." ///
>         1.heizart "Central heating" 2.heizart "Floor heating" 3.heizart "Oven" 99.heizart "n.a." ///
>         3.qualitaet "Superior" 4.qualitaet "Normal" 5.qualitaet "Basic"  99.qualitaet "n.a." ///
>         grundflaeche "Lot size, in \$m^2\$" ///
>         wohnflaeche "Living space, in \$m^2\$" ///
>         zimmer_cont "\% of rooms" ///
>         grundflaeche2 "Lot size (squared)" ///
>         wohnflaeche2 "Living space (squared)" ///
>         zimmer_cont2 "\# of rooms (squared)" ///
>         _cons "Constant" ///
>         ) /// 
>         drop(1900.baujahr_adopt 1900.modern_adopt 3.qualitaet 1.objektzus 1.heizart 5.anbietertyp) /* drop base categories */ ///
>         order(1900.baujahr_adopt 1977.baujahr_adopt 2002.baujahr_adopt 9999.baujahr_adopt ///
>         1900.modern_adopt 1977.modern_adopt 2002.modern_adopt 9999.modern_adopt ///
>         3.qualitaet 4.qualitaet 5.qualitaet 99.qualitaet ///
>         0.objektzus 1.objektzus 99.objektzus  ///
>         1.heizart 2.heizart 3.heizart 99.heizart  ///
>         2.anbietertyp 4.anbietertyp 5.anbietertyp ///
>         1.postmai ///
>         2.anbietertyp#1.postmai 4.anbietertyp#1.postmai ///
>         2.objektkat 3.objektkat 99.objektkat ///
>         grundflaeche grundflaeche2 ///
>         wohnflaeche wohnflaeche2 ///
>         zimmer_cont zimmer_cont2 ///
>         _cons ///
>         ) ///
>         replace

----------------------------------------
               disclosure               
                   Coeff.      Std. Err.
----------------------------------------
1977-2002            .029**        .0017
2002-2015            .032**        .0026
n.a.                                    
1977-2001            .024*          .011
2002-2015            .022*          .011
n.a.                -.014            .01
Normal              -.024**        .0025
Basic               -.041**        .0043
n.a.                -.035**        .0024
Yes                 -.051**        .0025
n.a.                -.058**        .0017
Floor heat~g        -.013**        .0043
Oven                 -.02**        .0047
n.a.                 -.07**        .0016
Banks                .002          .0036
Agents              -.012**        .0032
PostApril             .27**        .0045
Banks*Post~l          .45**        .0052
Agents*Pos~l          .21**        .0048
Multi-fami~e       -.0089**        .0028
One-family~e       -.0011          .0019
n.a.                 -.13**        .0027
Lot size,~2$        .0022          .0032
Lot size (~)       -.0022**       .00075
Living sp~2$         .015**        .0044
Living spa~)       -.0052**       .00088
\% of rooms         .0046**       .00046
\# of room~)                            
Constant              .12**         .012
----------------------------------------
N                 312,899               
----------------------------------------

. 
. est drop disclosure

. 
. 
. ***
. * Page 13: Kolmogorov-Smirnov test
. ***
. ksmirnov evk ${ifnotlastmonth} & !missing(evk), by(postmai)

Two-sample Kolmogorov-Smirnov test for equality of distribution functions

 Smaller group       D       P-value  
 -----------------------------------
 0:                  0.1471    0.000
 1:                  0.0000    1.000
 Combined K-S:       0.1471    0.000

Note: Ties exist in combined dataset;
      there are 8780 unique values out of 102591 observations.

. 
. 
. 
. 
. ***
. * Table 4, Panel (1): Estimates of the Effect of Energy Information Disclosure on House Prices (OLS)
. ***
. 
. * sample is the same as for the panel analyses
. xtreg logkaufp epc $merkat_i $merkont ib1.objektzus ib5.anbietertyp i.monat if multlist > 0, fe 
note: 4.anbietertyp omitted because of collinearity
note: 5b.anbietertyp identifies no observations in the sample

Fixed-effects (within) regression               Number of obs     =     65,486
Group variable: plz                             Number of groups  =      7,333

R-sq:                                           Obs per group:
     within  = 0.5501                                         min =          1
     between = 0.1702                                         avg =        8.9
     overall = 0.2936                                         max =        119

                                                F(56,58097)       =    1268.53
corr(u_i, Xb)  = -0.0084                        Prob > F          =     0.0000

-----------------------------------------------------------------------------------
         logkaufp |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
------------------+----------------------------------------------------------------
              epc |   .0798372   .0035879    22.25   0.000     .0728049    .0868695
                  |
    baujahr_adopt |
            1977  |    .276368   .0032419    85.25   0.000     .2700137    .2827222
            2002  |   .4160657   .0051054    81.50   0.000     .4060592    .4260722
                  |
     modern_adopt |
            1977  |   .0634623     .02682     2.37   0.018     .0108949    .1160298
            2002  |   .0753273   .0263905     2.85   0.004     .0236018    .1270528
            9999  |   .0400685   .0261849     1.53   0.126     -.011254    .0913911
                  |
        objektkat |
             MFH  |   .0118732   .0056272     2.11   0.035      .000844    .0229025
   EFH, Bungalow  |   .1003603   .0040149    25.00   0.000      .092491    .1082296
              kA  |  -.0400229   .0050747    -7.89   0.000    -.0499693   -.0300766
                  |
        qualitaet |
          normal  |  -.1179741   .0053171   -22.19   0.000    -.1283957   -.1075526
         einfach  |   -.219141   .0092792   -23.62   0.000    -.2373283   -.2009537
              kA  |  -.0874096   .0047736   -18.31   0.000    -.0967658   -.0780534
                  |
          heizart |
   Etagenheizung  |  -.0737987   .0086943    -8.49   0.000    -.0908395   -.0567578
     Ofenheizung  |  -.2042812   .0098007   -20.84   0.000    -.2234906   -.1850719
              kA  |  -.0408716   .0032655   -12.52   0.000    -.0472719   -.0344712
                  |
     grundflaeche |   .3426425   .0058578    58.49   0.000     .3311612    .3541239
      wohnflaeche |   .5700637   .0083164    68.55   0.000     .5537635    .5863639
      zimmer_cont |  -.0052879   .0008807    -6.00   0.000    -.0070141   -.0035617
    grundflaeche2 |  -.0567278   .0013712   -41.37   0.000    -.0594153   -.0540403
     wohnflaeche2 |  -.0624399   .0016432   -38.00   0.000    -.0656606   -.0592192
                  |
        objektzus |
renovierungsbed.  |  -.2693291   .0051584   -52.21   0.000    -.2794397   -.2592186
              kA  |  -.1244132   .0034503   -36.06   0.000    -.1311757   -.1176507
                  |
      anbietertyp |
        Finanzen  |  -.0319558   .0038483    -8.30   0.000    -.0394985   -.0244131
          Makler  |          0  (omitted)
          privat  |          0  (empty)
                  |
            monat |
             637  |     .00742    .022994     0.32   0.747    -.0376482    .0524883
             638  |    .045035    .021408     2.10   0.035     .0030753    .0869947
             639  |   .0236923     .02148     1.10   0.270    -.0184085    .0657932
             640  |   .0271269   .0211336     1.28   0.199    -.0142952    .0685489
             641  |   .0260728   .0209067     1.25   0.212    -.0149046    .0670501
             642  |   .0369687   .0209734     1.76   0.078    -.0041392    .0780766
             643  |   .0348391   .0210035     1.66   0.097    -.0063278    .0760061
             644  |   .0311382   .0208602     1.49   0.136    -.0097479    .0720243
             645  |   .0371926   .0208771     1.78   0.075    -.0037266    .0781117
             646  |   .0311848   .0209179     1.49   0.136    -.0098144    .0721839
             647  |   .0273598   .0210835     1.30   0.194    -.0139639    .0686835
             648  |   .0349547   .0208651     1.68   0.094    -.0059409    .0758503
             649  |   .0432949   .0208812     2.07   0.038     .0023677    .0842221
             650  |   .0482171   .0208581     2.31   0.021     .0073351     .089099
             651  |   .0458507   .0204431     2.24   0.025     .0057821    .0859194
             652  |   .0198931   .0208059     0.96   0.339    -.0208865    .0606728
             653  |   .0115769   .0208893     0.55   0.579    -.0293662    .0525199
             654  |   .0210761   .0207274     1.02   0.309    -.0195497    .0617019
             655  |   .0039177   .0208123     0.19   0.851    -.0368746    .0447099
             656  |   .0057144   .0207416     0.28   0.783    -.0349393     .046368
             657  |   .0124591    .020837     0.60   0.550    -.0283815    .0532998
             658  |    .010933   .0208191     0.53   0.599    -.0298726    .0517385
             659  |   .0333823   .0212304     1.57   0.116    -.0082294     .074994
             660  |   .0119252   .0208582     0.57   0.568    -.0289569    .0528073
             661  |   .0100264    .021001     0.48   0.633    -.0311357    .0511886
             662  |   .0388858   .0208436     1.87   0.062    -.0019677    .0797393
             663  |   .0351172   .0210496     1.67   0.095    -.0061402    .0763745
             664  |   .0426083   .0212991     2.00   0.045      .000862    .0843546
             665  |    .038874   .0212062     1.83   0.067    -.0026903    .0804383
             666  |   .0382137   .0212533     1.80   0.072    -.0034428    .0798702
             667  |   .0276292   .0213607     1.29   0.196    -.0142377    .0694962
             668  |   .0314347   .0211021     1.49   0.136    -.0099255    .0727949
             669  |    .072638   .0199783     3.64   0.000     .0334805    .1117955
                  |
            _cons |   11.21641   .0338577   331.28   0.000     11.15005    11.28277
------------------+----------------------------------------------------------------
          sigma_u |  .55607271
          sigma_e |  .31611746
              rho |  .75575962   (fraction of variance due to u_i)
-----------------------------------------------------------------------------------
F test that all u_i=0: F(7332, 58097) = 16.87                Prob > F = 0.0000

. est sto hedonic

. 
. estout hedonic, ///
>         cells(b(fmt(3) star) se(fmt(3)) ci ) ///
>         stats(N N_clust, fmt(%9.0fc %9.0fc)) ///
>         varwidth(30) starlevels(* 0.05 ** 0.01) ///
>         keep( *epc*) // style(tex)

---------------------------------------------
                                    hedonic  
                                  b/se/ci95  
---------------------------------------------
epc                                   0.080**
                                      0.004  
                                0.073,0.087  
---------------------------------------------
N                                    65,486  
N_clust                                      
---------------------------------------------

. 
.         
. ***
. * Table 6 (Online Appendix G): OLS Regression Results for Linear Probability Model (all parameter estimates)
. ***
. estout hedonic, /// using "${TABLES}/$DATE_disclosure_appendix.txt", ///
>         cells("b(star label(Coeff.) fmt(%12.2gc)) se(label(Std. Err.) fmt(%12.2gc))") ///
>         starlevels(* 0.05 ** 0.01) ///
>         stats(N, fmt(%12.0fc)) ///
>         nobaselevels /// 
>         varlabels( ///
>         epc "EPC" ///
>         1900.baujahr_adopt "1900-1976" 1977.baujahr_adopt "1977-2002" 2002.baujahr_adopt "2002-2015" 9999.baujahr_adopt "n.a." ///
>         1900.modern_adopt "1900-1976" 1977.modern_adopt "1977-2001" 2002.modern_adopt "2002-2015" 9999.modern_adopt "n.a." ///
>         2.objektkat "Multi-family house" 3.objektkat "One-family house" 99.objektkat "n.a." ///
>         2.anbietertyp "Banks" 4.anbietertyp "Agents" 5.anbietertyp "Private" ///
>         1.postmai "PostApril" ///
>         2.anbietertyp#1.postmai "Banks*PostApril" 4.anbietertyp#1.postmai "Agents*PostApril" ///
>         0.objektzus "Yes" 1.objektzus "No" 99.objektzus "n.a." ///
>         1.heizart "Central heating" 2.heizart "Floor heating" 3.heizart "Oven" 99.heizart "n.a." ///
>         3.qualitaet "Superior" 4.qualitaet "Normal" 5.qualitaet "Basic"  99.qualitaet "n.a." ///
>         grundflaeche "Lot size, in \$m^2\$" ///
>         wohnflaeche "Living space, in \$m^2\$" ///
>         zimmer_cont "\# of rooms" ///
>         grundflaeche2 "Lot size (squared)" ///
>         wohnflaeche2 "Living space (squared)" ///
>         zimmer_cont2 "\% of rooms (squared)" ///
>         _cons "Constant" ///
>         ) ///   
>         drop(1900.baujahr_adopt 1900.modern_adopt 3.qualitaet 1.objektzus 1.heizart 5.anbietertyp *monat) /* drop base categories */ ///
>         order(epc ///
>         1900.baujahr_adopt 1977.baujahr_adopt 2002.baujahr_adopt ///    
>         1900.modern_adopt 1977.modern_adopt 2002.modern_adopt 9999.modern_adopt ///     
>         3.qualitaet 4.qualitaet 5.qualitaet 99.qualitaet ///
>         0.objektzus 1.objektzus 99.objektzus  ///
>         1.heizart 2.heizart 3.heizart 99.heizart  ///
>         2.anbietertyp 4.anbietertyp 5.anbietertyp ///
>         2.objektkat 3.objektkat 99.objektkat ///
>         grundflaeche grundflaeche2 ///
>         wohnflaeche wohnflaeche2 ///
>         zimmer_cont ///
>         _cons ///
>         ) ///
>         replace

----------------------------------------
                  hedonic               
                   Coeff.      Std. Err.
----------------------------------------
EPC                   .08**        .0036
1977-2002             .28**        .0032
2002-2015             .42**        .0051
1977-2001            .063*          .027
2002-2015            .075**         .026
n.a.                  .04           .026
Normal               -.12**        .0053
Basic                -.22**        .0093
n.a.                -.087**        .0048
Yes                  -.27**        .0052
n.a.                 -.12**        .0035
Floor heat~g        -.074**        .0087
Oven                  -.2**        .0098
n.a.                -.041**        .0033
Banks               -.032**        .0038
Agents                  0              .
Multi-fami~e         .012*         .0056
One-family~e           .1**         .004
n.a.                 -.04**        .0051
Lot size,~2$          .34**        .0059
Lot size (~)        -.057**        .0014
Living sp~2$          .57**        .0083
Living spa~)        -.062**        .0016
\# of rooms        -.0053**       .00088
Constant               11**         .034
----------------------------------------
N                  65,486               
----------------------------------------

.         
. if ($LOGTIME == 1) log close
      name:  <unnamed>
       log:  C:/Users/agerster/Dropbox/Projekt_Gebaeudeausweis/Auswertung JAERE_final/log/2019_6_5_analyses_disclosure.log
  log type:  text
 closed on:   5 Jun 2019, 14:36:07
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
